Top Microsoft Excel Shortcuts, Tips, and Tricks For Beginners: A Step By Step Guide by Steve Richard

Author:Steve, Richard [Steve, Richard]
Language: eng
Format: epub
Published: 2020-07-31T16:00:00+00:00

Click the Data tab, click Data Validation under the Data Tools group.

Change the Allow box to List.

Click the Source box, and drag down the original list of countries. Your list would be added to the box. Then, click OK.

Click on the dropdown icon to view the list you just created. Then, you can always select from those values.

THE FILL HANDLE

This feature is always on the lower right corner whenever you click on a cell. When you place your mouse on it, your mouse will turn to a small + sign. It can be used to fill down simple patterns of data in Excel.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.